#pragma once


namespace testDB {

	using namespace System;
	using namespace System::ComponentModel;
	using namespace System::Collections;
	using namespace System::Windows::Forms;
	using namespace System::Data;
	using namespace System::Drawing;

	//SQLite
	using namespace System::Data::SQLite;
	using namespace System::Text;

	/// <summary>
	/// Summary for Form1
	///
	/// WARNING: If you change the name of this class, you will need to change the
	///          'Resource File Name' property for the managed resource compiler tool
	///          associated with all .resx files this class depends on.  Otherwise,
	///          the designers will not be able to interact properly with localized
	///          resources associated with this form.
	/// </summary>
	public ref class Form1 : public System::Windows::Forms::Form
	{
	public:
		Form1(void)
		{
			InitializeComponent();
			//
			//TODO: Add the constructor code here
			//
		}

	protected:
		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		~Form1()
		{
			if (components)
			{
				delete components;
			}
		}
	private: System::Windows::Forms::TextBox^  textBox1;
	private: System::Windows::Forms::Button^  button1;
	private: System::Windows::Forms::Label^  label1;
	protected: 

	private:
		/// <summary>
		/// Required designer variable.
		/// </summary>
		System::ComponentModel::Container ^components;

#pragma region Windows Form Designer generated code
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		void InitializeComponent(void)
		{
			this->textBox1 = (gcnew System::Windows::Forms::TextBox());
			this->button1 = (gcnew System::Windows::Forms::Button());
			this->label1 = (gcnew System::Windows::Forms::Label());
			this->SuspendLayout();
			// 
			// textBox1
			// 
			this->textBox1->Location = System::Drawing::Point(12, 25);
			this->textBox1->Multiline = true;
			this->textBox1->Name = L"textBox1";
			this->textBox1->Size = System::Drawing::Size(260, 395);
			this->textBox1->TabIndex = 0;
			// 
			// button1
			// 
			this->button1->Location = System::Drawing::Point(197, 426);
			this->button1->Name = L"button1";
			this->button1->Size = System::Drawing::Size(75, 23);
			this->button1->TabIndex = 1;
			this->button1->Text = L"testDB";
			this->button1->UseVisualStyleBackColor = true;
			this->button1->Click += gcnew System::EventHandler(this, &Form1::button1_Click);
			// 
			// label1
			// 
			this->label1->AutoSize = true;
			this->label1->Location = System::Drawing::Point(12, 9);
			this->label1->Name = L"label1";
			this->label1->Size = System::Drawing::Size(82, 13);
			this->label1->TabIndex = 2;
			this->label1->Text = L"From Database:";
			// 
			// Form1
			// 
			this->AutoScaleDimensions = System::Drawing::SizeF(6, 13);
			this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
			this->ClientSize = System::Drawing::Size(284, 454);
			this->Controls->Add(this->label1);
			this->Controls->Add(this->button1);
			this->Controls->Add(this->textBox1);
			this->Name = L"Form1";
			this->Text = L"Form1";
			this->ResumeLayout(false);
			this->PerformLayout();

		}
#pragma endregion
	private: System::Void button1_Click(System::Object^  sender, System::EventArgs^  e) {
				// Create The Connection Object
				SQLiteConnection ^db = gcnew SQLiteConnection();
				try {
						// Open Database Connection
						MessageBox::Show("Opening Database Connection To sqlitedb.db ...");
						db->ConnectionString = "Data Source=sqlitedb.db";
						db->Open();
						MessageBox::Show("Database Connection To sqlitedb.db Opened.");

						// Display Table
						try {
								MessageBox::Show("Displaying Table ...");
								SQLiteCommand ^cmdSelect = db->CreateCommand();
								cmdSelect->CommandText = "SELECT * FROM ipaddress;";
								SQLiteDataReader ^reader = cmdSelect->ExecuteReader();
								StringBuilder ^sb = gcnew StringBuilder();
								for (int colCtr = 0; colCtr < reader->FieldCount; ++colCtr) {
									
									// Add Seperator (If After First Column)
									if (colCtr > 0) sb->Append("|");

									// Add Column Name
									sb->Append(reader->GetName(colCtr));
								}
								sb->AppendLine();
								sb->Append("~~~~~~~~~~~~");
								sb->AppendLine();
								while (reader->Read()) {
									for (int colCtr = 0; colCtr < reader->FieldCount; ++colCtr) {
										// Add Seperator (If After First Column)
										if (colCtr > 0) sb->Append("|");

										// Add Column Text
										sb->Append(reader->GetValue(colCtr)->ToString());
									}
									sb->AppendLine();
								}
								// Browse result
								//  ...by use textBox1
								this->textBox1->AppendText(sb->ToString());
								// ...or like this method
								// MessageBox::Show(sb->ToString(), "SQLite MyTable");
							}	catch (Exception ^e) {
									MessageBox::Show("Error Executing SQL: " + e->ToString(), "Exception While Displaying MyTable ...");
							}
						// Close Database Connection
						MessageBox::Show("Closing Database Connection To sqlitedb.db ...");
						db->Close();
						MessageBox::Show("Database Connection To sqlitedb.db Closed.");
					}	finally {
							// Dispose Database Connection
							delete (IDisposable^)db;
					}
			 }
	};
}

